So he just got done talking about importing a very popular document typed into excel.
We were talking about importing text files and specifically a tab delimited text file into our Excel
workbook.
Now we're going to switch gears here a little bit and we're going to talk about another very popular
source of data called Microsoft Access.
So if you're a Microsoft Access database user this one right here will become very important to you
as you may want to take a specific table from the Access database and import that into Excel so that
you can do your calculations or do your filtering or do your pivot tables or whatever it might be.
But do it inside of Excel versus working with tools inside of Access.
Now just like the previous lecture where we talked about importing text files this is a super simple
feature.
It's a simple little wizard that will allow us to hook up to that Access database grab the specific
table that we want from that database and import it into Excel.
So take a look.
First step I'm going to go up to my data tab.
Top of the screen this is the same place that we found from text.
So underneath the Get External Data section.
This time I'm going to go from access so I'll grab from access.
Now I got to go locate my Access database so I'm going to go visit my one drive account go into my office
nube am going live videos in Microsoft Office videos and now I'm just locating the exercise files that
I have here.
And this comes with this course and it's called North when DB it's an ACC database or an Access database
.
If you haven't downloaded this and you want to try this out go back to lecture to of course and grab
that file that's where you can practice this.
So I'll grab the Northwind db file.
I'm going to go ahead and open it now access if you're unfamiliar with Access Microsoft Access is a
database tool.
And inside the database you're going to have multiple tables that contain bits and pieces of a larger
picture.
For example inside this database I scroll down here I can see that I have tables like a customer's table
and employees table orders table products table and so on.
Each of these tables kind of isolating the data from one another.
Later on you create relationships and you can join them together to build to span data across.
And so I can see customers and their orders in one area and this is actually called the query.
Up above I've got a number of different queries that I can pull from as well that live inside of this
Access database.
Now I'm going to grab a single table.
I'll grab customers.
That's it.
So this is going to contain just customer information from this Access database.
I mean to go ahead.
OK.
Just wanted to know what do you want to do with it.
I'm going to put it in a table I'm going to put it in an existing worksheet instead of A1 and I'll hit
OK.
And I've now imported data from Microsoft Access and there it is.
This is the customer table customer I.D. company name contact name contact and so on all the records
from that table within the access database.
Again just like before with the text file really simple data import wethers from tax is from a database
.
Watch you do a simple little wizard.
And even now import the data into Excel.
Now you can do what you like.
You could run filter's calculations turn it into a pivot table summarize the data whatever you want
to do with this data.
You can now work with it here inside of Excel.
Try this out again lecture to download the database file from there.
The Northwind database file and then jump into Excel hopper to data to import from Access.
Go grab a table like grab customers customer share but you've got orders in employees and products and
so on.
Try important and